USE SAS
GO

 IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetUserCitiesXML')
	BEGIN
		DROP  Procedure  dbo.GetUserCitiesXML
	END

GO

CREATE Procedure dbo.GetUserCitiesXML
	@USERID		VARCHAR(10)
AS
BEGIN

	SELECT dbo.GetCityXML(@USERID)
	
END
GO

-- exec GetUserCitiesXML 1